﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage/MasterPage.master" AutoEventWireup="true" CodeFile="WorkTime_SV_EmpCardId.aspx.cs" Inherits="WorkTime_WorkTime_SV_EmpCardId" %>
<%@ Register Assembly="ZLTextBox" Namespace="BaseText" TagPrefix="cc1" %>
<asp:Content ID="Content1" ContentPlaceHolderID="Titile" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="Content" Runat="Server">
 <InfoLight:WebDataSource ID="Master" runat="server" AutoApply="True" WebDataSetID="WMaster" AllowAdd="True" AllowDelete="True" AllowPrint="True" AllowUpdate="True" AlwaysClose="False" AutoApplyForInsert="False" AutoRecordLock="False" AutoRecordLockMode="NoneReload" CacheDataSet="False" CommandName="" CommandText="" DataMember="WorkTime_SV_EmpCardId" Eof="True" KeyValues="" LastIndex="-1" Marker="'" MasterDataSource="" PacketRecords="100" QuotePrefix="[" QuoteSuffix="]" RemoteName="" SelectCommand="" TableName="" SelectAlias="">
        </InfoLight:WebDataSource>
          <InfoLight:WebDataSource ID="wdsWorkTime_SV_EmpCardIdEmployeeId" runat="server" SelectAlias="Usasdb" SelectCommand="SELECT Employees.EmployeeID, Employees.EmpName, 
      Department.DepartmentName
FROM Employees INNER JOIN
      Department ON 
      Employees.DepartmentId = Department.DepartmentId
WHERE (Employees.EmpStatus = 1)">
</InfoLight:WebDataSource>
<InfoLight:WebValidate ID="wvWorkTime_SV_EmpCardId" runat="server" DataMember="WorkTime_SV_EmpCardId" DataSourceID="Master" ForeColor="Red" ValidateChar="*" AltRowCss="" RowCss="" DuplicateCheck="True" DuplicateCheckMode="ByWhere"><Fields>
<InfoLight:ValidateFieldItem FieldName="CardId" CheckNull="True" WarningMsg="门禁卡号有误" CheckRangeFrom="0000" CheckRangeTo="9999"></InfoLight:ValidateFieldItem>
<InfoLight:ValidateFieldItem FieldName="EmployeeId" CheckNull="True" WarningMsg="员工数据有问题" CheckRangeFrom="" CheckRangeTo=""></InfoLight:ValidateFieldItem>
</Fields>
</InfoLight:WebValidate>
<InfoLight:WebNavigator ID="WebNavigator1" runat="server" BindingObject="wgvMaster"
            Width="100%" StatusStrip="WebStatusStrip1" ShowDataStyle="GridStyle" 
        QueryKeepConditon="True" CssClass="NavigatorBar" CtlHeight="25">
            <NavControls>
                <InfoLight:ControlItem ControlName="Add" ControlText="穝糤" ControlType="Image" ControlVisible="True"
                    ImageUrl="../image/uipics/add_C.gif" MouseOverImageUrl="../image/uipics/add2_C.gif"
                    Size="48"  disenableimageurl="../Image/UIPics/add3_C.gif"/>
                <InfoLight:ControlItem ControlName="Apply" ControlText="郎" ControlType="Image" ControlVisible="True"
                    ImageUrl="../image/uipics/apply_C.gif" MouseOverImageUrl="../image/uipics/apply2_C.gif"
                    Size="48"  disenableimageurl="../Image/UIPics/apply3_C.gif"/>
                <InfoLight:ControlItem ControlName="Abort" ControlText="斌" ControlType="Image" ControlVisible="True"
                    ImageUrl="../image/uipics/abort_C.gif" MouseOverImageUrl="../image/uipics/abort2_C.gif"
                    Size="48"  disenableimageurl="../Image/UIPics/abort3_C.gif"/>
                <InfoLight:ControlItem ControlName="Query" ControlText="琩高" ControlType="Image" ControlVisible="True"
                    ImageUrl="../image/uipics/query_C.gif" MouseOverImageUrl="../image/uipics/query2_C.gif"
                    Size="48"  disenableimageurl="../Image/UIPics/query3_C.gif"/>
                <InfoLight:ControlItem ControlName="Print" ControlText="ゴ" ControlType="Image" ControlVisible="False"
                    ImageUrl="../image/uipics/print_C.gif" MouseOverImageUrl="../image/uipics/print2_C.gif"
                    Size="48"  disenableimageurl="../Image/UIPics/print3_C.gif"/>
            </NavControls>
            <NavStates>
                <InfoLight:WebNavigatorStateItem StateText="Initial" />
                <InfoLight:WebNavigatorStateItem StateText="Browsed" />
                <InfoLight:WebNavigatorStateItem StateText="Inserting" />
                <InfoLight:WebNavigatorStateItem StateText="Editing" />
                <InfoLight:WebNavigatorStateItem StateText="Applying" />
                <InfoLight:WebNavigatorStateItem StateText="Changing" />
                <InfoLight:WebNavigatorStateItem StateText="Querying" />
                <InfoLight:WebNavigatorStateItem StateText="Printing" />
            </NavStates>
        </InfoLight:WebNavigator>
        <InfoLight:webgridview id="wgvMaster" runat="server"
            cellpadding="5" datasourceid="Master" forecolor="#333333" width="100%" 
        AbortIconUrl="../Image/UIPics/Abort.gif" AddIconUrl="../Image/UIPics/Add.gif" 
        ApplyIconUrl="../Image/UIPics/Apply.gif" 
        CancelIconUrl="../Image/UIPics/Cancel.gif" 
        MouseOverAbortIconUrl="../Image/UIPics/Abort2.gif" 
        MouseOverAddIconUrl="../Image/UIPics/Add2.gif" 
        MouseOverApplyIconUrl="../Image/UIPics/Apply2.gif" 
        MouseOverCancelIconUrl="../Image/UIPics/Cancel2.gif" 
        MouseOverOKIconUrl="../Image/UIPics/OK2.gif" 
        MouseOverQueryIconUrl="../Image/UIPics/Query2.gif" 
        OKIconUrl="../Image/UIPics/OK.gif" QueryIconUrl="../Image/UIPics/Query.gif" 
        HeaderStyleWrap="False" BackColor="White" BorderColor="White" 
        BorderStyle="Groove" BorderWidth="2px" DataMember="WorkTime_SV_EmpCardId" 
        AllowSorting="True" PageSize="15">
            <PagerSettings Mode="NumericFirstLast" />
<FooterStyle BackColor="#507CD1" ForeColor="White" Font-Bold="True"></FooterStyle>
            <navcontrols>
<InfoLight:ControlItem ControlVisible="True" Size="25" MouseOverImageUrl="../image/uipics/add2.gif" ControlText="add" ControlName="Add" ControlType="Image" ImageUrl="../image/uipics/add.gif"></InfoLight:ControlItem>
<InfoLight:ControlItem ControlVisible="True" Size="25" MouseOverImageUrl="../image/uipics/ok2.gif" ControlText="Insert" ControlName="OK" ControlType="Image" ImageUrl="../image/uipics/ok.gif"></InfoLight:ControlItem>
<InfoLight:ControlItem ControlVisible="True" Size="25" MouseOverImageUrl="../image/uipics/cancel2.gif" ControlText="cancel" ControlName="Cancel" ControlType="Image" ImageUrl="../image/uipics/cancel.gif"></InfoLight:ControlItem>
</navcontrols>
            <Columns>
                <asp:CommandField ButtonType="Image" CancelImageUrl="~/Image/UIPics/Cancel.gif" DeleteImageUrl="~/Image/UIPics/Delete.gif"
                    EditImageUrl="~/Image/UIPics/Edit.gif" 
                    ShowDeleteButton="True" ShowEditButton="True" UpdateImageUrl="~/Image/UIPics/OK.gif" SelectText="" />
   <asp:TemplateField HeaderText="门禁卡号" SortExpression="CardId">
      <edititemtemplate>
         <cc1:ZLTextBox id="ZLTextBox2" language="English" Text='<%# Bind("CardId") %>' runat="server" IsDisplayTime="False" InputType="number"></cc1:ZLTextBox>
        
</edititemtemplate>
  <footertemplate>
   <cc1:ZLTextBox id="ZLTextBox1" language="English" Text='<%# Bind("CardId") %>' runat="server" IsDisplayTime="False" InputType="number"></cc1:ZLTextBox>
  
</footertemplate>
                    <itemtemplate>
<asp:Label id="Label1" runat="server" Text='<%# Bind("CardId") %>'></asp:Label>
</itemtemplate>
                </asp:TemplateField>
                  <asp:TemplateField HeaderText="员工" SortExpression="EmployeeId">
                    <edititemtemplate>
<InfoLight:WebRefVal id="wrvWorkTime_SV_EmpCardIdEmployeeIdE" runat="server" Width="130px" DataSourceID="wdsWorkTime_SV_EmpCardIdEmployeeId" ReadOnly="True" DataBindingField="EmployeeId" MultiLanguage="False" ResxFilePath="" BindingText="" ButtonImageUrl="../Image/refval/RefVal.gif" DataValueField="EmployeeID" UpdatePanelID="" ResxDataSet="" BindingValue='<%# Bind("EmployeeId") %>' UseButtonImage="True" PostBackButonClick="False" AllowAddData="False" DataTextField="EmpName"><Columns>
<InfoLight:WebRefColumn HeadText="所在部门" ColumnName="DepartmentName" Width="100"></InfoLight:WebRefColumn>
<InfoLight:WebRefColumn HeadText="员工编号" ColumnName="EmployeeID" Width="100"></InfoLight:WebRefColumn>
<InfoLight:WebRefColumn HeadText="员工姓名" ColumnName="EmpName" Width="100"></InfoLight:WebRefColumn>
</Columns>
</InfoLight:WebRefVal> 
</edititemtemplate>
                    <footertemplate>
<InfoLight:WebRefVal id="wrvWorkTime_SV_EmpCardIdEmployeeIdF" runat="server" Width="130px" DataSourceID="wdsWorkTime_SV_EmpCardIdEmployeeId" ReadOnly="False" DataBindingField="EmployeeId" MultiLanguage="False" ResxFilePath="" BindingText="" ButtonImageUrl="../Image/refval/RefVal.gif" DataValueField="EmployeeID" UpdatePanelID="" ResxDataSet="" BindingValue='<%# Bind("EmployeeId") %>' UseButtonImage="True" PostBackButonClick="False" AllowAddData="False" DataTextField="EmpName"><Columns>
<InfoLight:WebRefColumn HeadText="员工编号" ColumnName="EmployeeID" Width="100"></InfoLight:WebRefColumn>
<InfoLight:WebRefColumn HeadText="员工姓名" ColumnName="EmpName" Width="100"></InfoLight:WebRefColumn>
<InfoLight:WebRefColumn HeadText="所在部门" ColumnName="DepartmentName" Width="100"></InfoLight:WebRefColumn>
</Columns>
</InfoLight:WebRefVal> 
</footertemplate>
                    <itemtemplate>
<InfoLight:WebRefVal id="wrvWorkTime_SV_EmpCardIdEmployeeId" runat="server" Width="130px" BorderStyle="None" BackColor="Transparent" DataSourceID="wdsWorkTime_SV_EmpCardIdEmployeeId" ReadOnly="True" DataBindingField="EmployeeId" MultiLanguage="False" ResxFilePath="" BindingText="" ButtonImageUrl="../Image/refval/RefVal.gif" DataValueField="EmployeeID" UpdatePanelID="" ResxDataSet="" BindingValue='<%# Bind("EmployeeId") %>' UseButtonImage="True" PostBackButonClick="False" AllowAddData="False" DataTextField="EmpName"><Columns>
<InfoLight:WebRefColumn HeadText="所在部门" ColumnName="DepartmentName" Width="100"></InfoLight:WebRefColumn>
<InfoLight:WebRefColumn HeadText="员工编号" ColumnName="EmployeeID" Width="100"></InfoLight:WebRefColumn>
<InfoLight:WebRefColumn HeadText="员工姓名" ColumnName="EmpName" Width="100"></InfoLight:WebRefColumn>
</Columns>
</InfoLight:WebRefVal> 
</itemtemplate>
 </asp:TemplateField>
                <asp:TemplateField HeaderText="门禁卡未使用" SortExpression="NoUse">
                    <edititemtemplate>
<asp:CheckBox id="CheckBox1" runat="server" Checked='<%# Bind("NoUse") %>' __designer:wfdid="w2"></asp:CheckBox> 
</edititemtemplate>
                    <footertemplate>
<asp:CheckBox id="CheckBox1" runat="server" Checked='<%# Bind("NoUse") %>' __designer:wfdid="w3"></asp:CheckBox>
</footertemplate>
                    <itemtemplate>
<asp:CheckBox id="CheckBox1" runat="server" Enabled="false" Checked='<%# Bind("NoUse") %>' __designer:wfdid="w1"></asp:CheckBox> 
</itemtemplate>
                </asp:TemplateField>
                <asp:BoundField DataField="DepartmentName" HeaderText="部门名称" SortExpression="DepartmentName" ReadOnly="True"  />
</Columns>

<RowStyle BackColor="#EFF3FB"></RowStyle>

<EditRowStyle BackColor="#2461BF"></EditRowStyle>

<SelectedRowStyle BackColor="#D1DDF1" ForeColor="#333333" Font-Bold="True"></SelectedRowStyle>

<PagerStyle BackColor="LightBlue" ForeColor="White" HorizontalAlign="Center"></PagerStyle>

<HeaderStyle BackColor="DeepSkyBlue" ForeColor="White" Font-Bold="True"></HeaderStyle>

<AlternatingRowStyle BackColor="White" BorderColor="White"></AlternatingRowStyle>
            <AddNewRowControls>
                <InfoLight:AddNewRowControlItem ControlID="ZLTextBox1" ControlType="TextBox" FieldName="CardId" />
                <InfoLight:AddNewRowControlItem ControlID="wrvWorkTime_SV_EmpCardIdEmployeeIdF" ControlType="RefVal"
                    FieldName="EmployeeId" />
                <InfoLight:AddNewRowControlItem ControlID="CheckBox1" ControlType="CheckBox" FieldName="NoUse" />
            </AddNewRowControls>
</InfoLight:webgridview>
</asp:Content>

